﻿CREATE TABLE [v1bgt].[Journal] (
    [JournalId]              INT           IDENTITY (1, 1) NOT NULL,
    [CostCentreJournalSetId] INT           NOT NULL,
    [AdjustmentTypeId]       SMALLINT      NOT NULL,
    [CurrencyId]             SMALLINT      NOT NULL,
    [JournalDate]            DATETIME      NOT NULL,
    [PostingDate]            DATETIME      DEFAULT (getdate()) NOT NULL,
    [CreatedBy]              NVARCHAR (50) NULL,
    [JournalBatchId]         INT           NOT NULL,
    PRIMARY KEY CLUSTERED ([JournalId] ASC) WITH (FILLFACTOR = 90, ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

